SSN

Base Entity | Student
Attribute Name | SSN
Logical Rolename |
ColumnName | SSN
Definition |

TitleId

Base Entity | Student
Attribute Name | TitleId
Logical Rolename |
ColumnName | AmTitleID
Definition |

LastName

Base Entity | Student
Attribute Name | LastName
Logical Rolename |
ColumnName | LastName
Definition |

FirstName

Base Entity | Student
Attribute Name | FirstName
Logical Rolename |
ColumnName | FirstName
Definition |

NickName

Base Entity | Student
Attribute Name | NickName
Logical Rolename |
ColumnName | NickName
Definition |

MaidenName

Base Entity | Student
Attribute Name | MaidenName
Logical Rolename |
ColumnName | MaidenName
Definition |

StreetAddress

Base Entity | Student
Attribute Name | StreetAddress
Logical Rolename |
ColumnName | Addr1
Definition |

StreetAddress2

Base Entity | Student
Attribute Name | StreetAddress2
Logical Rolename |
ColumnName | Addr2
Definition |

City

Base Entity | Student
Attribute Name | City
Logical Rolename |
ColumnName | City
Definition |

State

Base Entity | Student
Attribute Name | State
Logical Rolename |
ColumnName | State
Definition |

PostalCode

Base Entity | Student
Attribute Name | PostalCode
Logical Rolename |
ColumnName | Zip
Definition |

IsBadAddress

Base Entity | Student
Attribute Name | IsBadAddress
Logical Rolename |
ColumnName | BadAddr
Definition |

Id

Base Entity | Student
Attribute Name | Id
Logical Rolename | Id
ColumnName | SyCountryID
Definition |

Id

Base Entity | Student
Attribute Name | Id
Logical Rolename | Id
ColumnName | SyCountyID
Definition |

PhoneNumber

Base Entity | Student
Attribute Name | PhoneNumber
Logical Rolename |
ColumnName | Phone
Definition |

WorkPhoneNumber

Base Entity | Student
Attribute Name | WorkPhoneNumber
Logical Rolename |
ColumnName | WorkPhone
Definition |

WorkPhoneNumberExtension

Base Entity | Student
Attribute Name | WorkPhoneNumberExtension
Logical Rolename |
ColumnName | Workext
Definition |

IsBadPhone

Base Entity | Student
Attribute Name | IsBadPhone
Logical Rolename |
ColumnName | BadPhone
Definition |

LeadDate

Base Entity | Student
Attribute Name | LeadDate
Logical Rolename |
ColumnName | LeadDate
Definition |

LeadTypeId

Base Entity | Student
Attribute Name | LeadTypeId
Logical Rolename |
ColumnName | AmLeadTypeID
Definition |

GenderId

Base Entity | Student
Attribute Name | GenderId
Logical Rolename |
ColumnName | AmSexID
Definition |

AmRaceID

Base Entity | Student
Attribute Name | AmRaceID
Logical Rolename |
ColumnName | AmRaceID
Definition |

NationalityId

Base Entity | Student
Attribute Name | NationalityId
Logical Rolename |
ColumnName | AmNationalityID
Definition |

MaritalStatusId

Base Entity | Student
Attribute Name | MaritalStatusId
Logical Rolename |
ColumnName | AmMaritalID
Definition |

DriverLicenseState

Base Entity | Student
Attribute Name | DriverLicenseState
Logical Rolename |
ColumnName | DrivLicState
Definition |

DriverLicenseNumber

Base Entity | Student
Attribute Name | DriverLicenseNumber
Logical Rolename |
ColumnName | DrivLic
Definition |

DateOfBirth

Base Entity | Student
Attribute Name | DateOfBirth
Logical Rolename |
ColumnName | DOB
Definition |

AlienNumber

Base Entity | Student
Attribute Name | AlienNumber
Logical Rolename |
ColumnName | AlienNo
Definition |

AgencyId

Base Entity | Student
Attribute Name | AgencyId
Logical Rolename |
ColumnName | AmAgencyID
Definition |

CitizenId

Base Entity | Student
Attribute Name | CitizenId
Logical Rolename |
ColumnName | AmCitizenID
Definition |

EmailAddress

Base Entity | Student
Attribute Name | EmailAddress
Logical Rolename |
ColumnName | email
Definition |

SchoolStatusId

Base Entity | Student
Attribute Name | SchoolStatusId
Logical Rolename |
ColumnName | SySchoolStatusID
Definition |

AssignedAdmissionsRepId

Base Entity | Student
Attribute Name | AssignedAdmissionsRepId
Logical Rolename |
ColumnName | AmRepID
Definition |

LeadSourceId

Base Entity | Student
Attribute Name | LeadSourceId
Logical Rolename | LeadSourceId
ColumnName | AmLeadSrcID
Definition |

CampusId

Base Entity | Student
Attribute Name | CampusId
Logical Rolename |
ColumnName | SyCampusID
Definition |

ProgramGroupId

Base Entity | Student
Attribute Name | ProgramGroupId
Logical Rolename |
ColumnName | AdProgramGroupID
Definition |

ProgramId

Base Entity | Student
Attribute Name | ProgramId
Logical Rolename |
ColumnName | AdProgramID
Definition |

ShiftId

Base Entity | Student
Attribute Name | ShiftId
Logical Rolename |
ColumnName | AdShiftID
Definition |

StartDate

Base Entity | Student
Attribute Name | StartDate
Logical Rolename |
ColumnName | StartDate
Definition |

PreviousEducationId

Base Entity | Student
Attribute Name | PreviousEducationId
Logical Rolename |
ColumnName | amPrevEducID
Definition |

HighSchoolId

Base Entity | Student
Attribute Name | HighSchoolId
Logical Rolename |
ColumnName | AmHighSchoolID
Definition |

CollegeId

Base Entity | Student
Attribute Name | CollegeId
Logical Rolename |
ColumnName | AmCollegeID
Definition |

HsGradDate

Base Entity | Student
Attribute Name | HsGradDate
Logical Rolename |
ColumnName | HsGradDate
Definition |

ARBalance

Base Entity | Student
Attribute Name | ARBalance
Logical Rolename |
ColumnName | ARBalance
Definition |

ArNextTransactionNumber

Base Entity | Student
Attribute Name | ArNextTransactionNumber
Logical Rolename |
ColumnName | NextTranNum
Definition |

ArAccountStatus

Base Entity | Student
Attribute Name | ArAccountStatus
Logical Rolename |
ColumnName | ArAcctStat
Definition |

LastStatementDate

Base Entity | Student
Attribute Name | LastStatementDate
Logical Rolename |
ColumnName | StmtLastDate
Definition |

LastStatementBeginDate

Base Entity | Student
Attribute Name | LastStatementBeginDate
Logical Rolename |
ColumnName | StmtBeginDate
Definition |

LastStatementCloseDate

Base Entity | Student
Attribute Name | LastStatementCloseDate
Logical Rolename |
ColumnName | StmtCloseDate
Definition |

StatementComment

Base Entity | Student
Attribute Name | StatementComment
Logical Rolename |
ColumnName | StmtComment
Definition |

DefaultAddressCode

Base Entity | Student
Attribute Name | DefaultAddressCode
Logical Rolename |
ColumnName | DefaultAddressCode
Definition |

DefaultStudentAddressId

Base Entity | Student
Attribute Name | DefaultStudentAddressId
Logical Rolename |
ColumnName | DefaultAddressID
Definition |

StudentNumber

Base Entity | Student
Attribute Name | StudentNumber
Logical Rolename |
ColumnName | StuNum
Definition |

PIN

Base Entity | Student
Attribute Name | PIN
Logical Rolename |
ColumnName | PIN
Definition |

Note

Base Entity | Student
Attribute Name | Note
Logical Rolename |
ColumnName | Comment
Definition |

ExtraCurricularActivityId

Base Entity | Student
Attribute Name | ExtraCurricularActivityId
Logical Rolename |
ColumnName | AmExtraCurrID
Definition |

IsActive

Base Entity | Student
Attribute Name | IsActive
Logical Rolename |
ColumnName | Active
Definition |

DataBlockIndicator

Base Entity | Student
Attribute Name | DataBlockIndicator
Logical Rolename |
ColumnName | DataBlockIndicator
Definition |

ModFlag

Base Entity | Student
Attribute Name | ModFlag
Logical Rolename |
ColumnName | ModFlag
Definition |

LastModifiedUserId

Base Entity | Student
Attribute Name | LastModifiedUserId
Logical Rolename |
ColumnName | Userid
Definition |

CreatedDateTime

Base Entity | Student
Attribute Name | CreatedDateTime
Logical Rolename |
ColumnName | DateAdded
Definition |

LastModifiedDateTime

Base Entity | Student
Attribute Name | LastModifiedDateTime
Logical Rolename |
ColumnName | DateLstMod
Definition |

RowVersion

Base Entity | Student
Attribute Name | RowVersion
Logical Rolename |
ColumnName | ts
Definition |

StudentId

Base Entity | Student
Attribute Name | StudentId
Logical Rolename |
ColumnName | SyStudentId
Definition |

Disabled

Base Entity | Student
Attribute Name | Disabled
Logical Rolename |
ColumnName | Disabled
Definition |

Veteran

Base Entity | Student
Attribute Name | Veteran
Logical Rolename |
ColumnName | Vet
Definition |

OriginalAssignedAdmissionsRepId

Base Entity | Student
Attribute Name | OriginalAssignedAdmissionsRepId
Logical Rolename |
ColumnName | OriginalAmRepID
Definition |

CumulativeGpa

Base Entity | Student
Attribute Name | CumulativeGpa
Logical Rolename |
ColumnName | CumGPA
Definition |

CumulativeGpaPoints

Base Entity | Student
Attribute Name | CumulativeGpaPoints
Logical Rolename |
ColumnName | CumGPAPoints
Definition |

CurrentLDA

Base Entity | Student
Attribute Name | CurrentLDA
Logical Rolename |
ColumnName | CurrentLDA
Definition |

GPACredits

Base Entity | Student
Attribute Name | GPACredits
Logical Rolename |
ColumnName | GPACredits
Definition |

OriginalStartDate

Base Entity | Student
Attribute Name | OriginalStartDate
Logical Rolename |
ColumnName | OriginalStartDate
Definition |

OriginalExpectedStartDate

Base Entity | Student
Attribute Name | OriginalExpectedStartDate
Logical Rolename |
ColumnName | OriginalExpStartDate
Definition |

OtherPhoneNumber

Base Entity | Student
Attribute Name | OtherPhoneNumber
Logical Rolename |
ColumnName | OtherPhone
Definition |

OtherEmailAddress

Base Entity | Student
Attribute Name | OtherEmailAddress
Logical Rolename |
ColumnName | OtherEmail
Definition |

LastActivityDate

Base Entity | Student
Attribute Name | LastActivityDate
Logical Rolename |
ColumnName | LastActivityDate
Definition |

LastInterestDate

Base Entity | Student
Attribute Name | LastInterestDate
Logical Rolename |
ColumnName | LastInterestDate
Definition |

DefaultMasterStudentAddressId

Base Entity | Student
Attribute Name | DefaultMasterStudentAddressId
Logical Rolename | DefaultMasterStudentAddressId
ColumnName | DefaultMasterAddressID
Definition |

Suffix

Base Entity | Student
Attribute Name | Suffix
Logical Rolename |
ColumnName | Suffix
Definition |

MiddleName

Base Entity | Student
Attribute Name | MiddleName
Logical Rolename |
ColumnName | MiddleName
Definition |

NIStudent

Base Entity | Student
Attribute Name | NIStudent
Logical Rolename |
ColumnName | NIStudent
Definition |

StudentIdentifier

Base Entity | Student
Attribute Name | StudentIdentifier
Logical Rolename |
ColumnName | StudentIdentifier
Definition |

PreviousEducationGpa

Base Entity | Student
Attribute Name | PreviousEducationGpa
Logical Rolename |
ColumnName | PrevEducGPA
Definition |

HSGraduated

Base Entity | Student
Attribute Name | HSGraduated
Logical Rolename |
ColumnName | HSGraduated
Definition |

HSGraduationSession

Base Entity | Student
Attribute Name | HSGraduationSession
Logical Rolename |
ColumnName | HSGraduationSession
Definition |

HSDateEnrolled

Base Entity | Student
Attribute Name | HSDateEnrolled
Logical Rolename |
ColumnName | HSDateEnrolled
Definition |

HSLastDateAttended

Base Entity | Student
Attribute Name | HSLastDateAttended
Logical Rolename |
ColumnName | HSLastDateAttended
Definition |

HSStudRank

Base Entity | Student
Attribute Name | HSStudRank
Logical Rolename |
ColumnName | HSStudRank
Definition |

HSSchoolSize

Base Entity | Student
Attribute Name | HSSchoolSize
Logical Rolename |
ColumnName | HSSchoolSize
Definition |

HSTranscriptType

Base Entity | Student
Attribute Name | HSTranscriptType
Logical Rolename |
ColumnName | HSTranscriptType
Definition |

HSStudLevel

Base Entity | Student
Attribute Name | HSStudLevel
Logical Rolename |
ColumnName | HSStudLevel
Definition |

HSGradYear

Base Entity | Student
Attribute Name | HSGradYear
Logical Rolename |
ColumnName | HSGradYear
Definition |

LastNameFirstFour

Base Entity | Student
Attribute Name | LastNameFirstFour
Logical Rolename |
ColumnName | LastName_FirstFour
Definition |

PostalCodeFirstThree

Base Entity | Student
Attribute Name | PostalCodeFirstThree
Logical Rolename |
ColumnName | Zip_FirstThree
Definition |

DBIModifiedDate

Base Entity | Student
Attribute Name | DBIModifiedDate
Logical Rolename |
ColumnName | DBIModifiedDate
Definition |

BestTimeToContact

Base Entity | Student
Attribute Name | BestTimeToContact
Logical Rolename |
ColumnName | BestTimeToContact
Definition |

RawLastName

Base Entity | Student
Attribute Name | RawLastName
Logical Rolename |
ColumnName | RawLastName
Definition |

RawFirstName

Base Entity | Student
Attribute Name | RawFirstName
Logical Rolename |
ColumnName | RawFirstName
Definition |

RawPhoneNumber

Base Entity | Student
Attribute Name | RawPhoneNumber
Logical Rolename |
ColumnName | RawPhone
Definition |

ACGEligReasonCode

Base Entity | Student
Attribute Name | ACGEligReasonCode
Logical Rolename |
ColumnName | ACGEligReasonCode
Definition |

FARigorousHighSchoolProgramCodeID

Base Entity | Student
Attribute Name | FARigorousHighSchoolProgramCodeID
Logical Rolename |
ColumnName | FARigorousHighSchoolProgramCodeID
Definition |

SmsServiceProviderId

Base Entity | Student
Attribute Name | SmsServiceProviderId
Logical Rolename |
ColumnName | CMSMSServiceProviderID
Definition |

SubscribeToSMS

Base Entity | Student
Attribute Name | SubscribeToSMS
Logical Rolename |
ColumnName | SubscribeToSMS
Definition |

MobilePhoneNumber

Base Entity | Student
Attribute Name | MobilePhoneNumber
Logical Rolename |
ColumnName | MobileNumber
Definition |

SourceSystem

Base Entity | Student
Attribute Name | SourceSystem
Logical Rolename |
ColumnName | SourceSystem
Definition |

HispanicLatino

Base Entity | Student
Attribute Name | HispanicLatino
Logical Rolename |
ColumnName | IsHispanic
Definition |

IsExcludedCrmIntegration

Base Entity | Student
Attribute Name | IsExcludedCrmIntegration
Logical Rolename |
ColumnName | CrmSuppressFlag
Definition |

IsDdVeteran

Base Entity | Student
Attribute Name | IsDdVeteran
Logical Rolename |
ColumnName | DDVeteran
Definition |

HSAcademicGPA

Base Entity | Student
Attribute Name | HSAcademicGPA
Logical Rolename |
ColumnName | HSAcademicGPA
Definition |

SuffixId

Base Entity | Student
Attribute Name | SuffixId
Logical Rolename |
ColumnName | AmSuffixID
Definition |

AthleticIdentifier

Base Entity | Student
Attribute Name | AthleticIdentifier
Logical Rolename |
ColumnName | AthleticID
Definition |

faGradPlusCounselingDate

Base Entity | Student
Attribute Name | faGradPlusCounselingDate
Logical Rolename |
ColumnName | faGradPlusCounselingDate
Definition |

IsInDistrict

Base Entity | Student
Attribute Name | IsInDistrict
Logical Rolename |
ColumnName | InDistrict
Definition |

IsEftDefaultForStipends

Base Entity | Student
Attribute Name | IsEftDefaultForStipends
Logical Rolename |
ColumnName | DefaultStipendsToEFT
Definition |

MI

Base Entity | Student
Attribute Name | MI
Logical Rolename |
ColumnName | MI
Definition |

PersonId

Base Entity | Student
Attribute Name | PersonId
Logical Rolename |
ColumnName | SyPersonId
Definition |

LeadSourceId

Base Entity | Student
Attribute Name | LeadSourceId
Logical Rolename | LeadSourceId
ColumnName | amLeadSrcID
Definition |

EmployerId

Base Entity | Student
Attribute Name | EmployerId
Logical Rolename |
ColumnName | PlEmployerID
Definition |

EmploymentStatusId

Base Entity | Student
Attribute Name | EmploymentStatusId
Logical Rolename |
ColumnName | PlEmpStatusID
Definition |

AdmissionsRepId

Base Entity | Student
Attribute Name | AdmissionsRepId
Logical Rolename |
ColumnName | AmRepId
Definition |

Id

Base Entity | Student
Attribute Name | Id
Logical Rolename | Id
ColumnName | amTitleID
Definition |